﻿<%@ Page Language="C#" MasterPageFile="~/Teacher/TeacMasterPage.master" AutoEventWireup="true" CodeFile="MultipleChoice.aspx.cs" Inherits="Teacher_Default2" Title="Untitled Page" %>
<%@ Register Src="../Control/ChooseQuestionType.ascx" TagName="ChooseQuestionType" TagPrefix="ChooseQuestionType" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentBody" Runat="Server">

<form runat="server">
    <ChooseQuestionType:ChooseQuestionType id="choose" runat="server" /><br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />
            <asp:BoundField DataField="answer" HeaderText="answer" SortExpression="answer" />
            <asp:BoundField DataField="hardLevel" HeaderText="hardLevel" SortExpression="hardLevel" />
            <asp:BoundField DataField="score" HeaderText="score" SortExpression="score" />
            <asp:BoundField DataField="date" HeaderText="date" SortExpression="date" />
            <asp:BoundField DataField="analysis" HeaderText="analysis" SortExpression="analysis" />
            <asp:BoundField DataField="choiceNum" HeaderText="choiceNum" SortExpression="choiceNum" />
            <asp:BoundField DataField="choiceA" HeaderText="choiceA" SortExpression="choiceA" />
            <asp:BoundField DataField="choiceB" HeaderText="choiceB" SortExpression="choiceB" />
            <asp:BoundField DataField="choiceC" HeaderText="choiceC" SortExpression="choiceC" />
            <asp:BoundField DataField="choiceD" HeaderText="choiceD" SortExpression="choiceD" />
            <asp:BoundField DataField="choiceE" HeaderText="choiceE" SortExpression="choiceE" />
            <asp:BoundField DataField="choiceF" HeaderText="choiceF" SortExpression="choiceF" />
            <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
            <asp:BoundField DataField="Expr1" HeaderText="Expr1" SortExpression="Expr1" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:onlineexamConnectionString %>"
        SelectCommand="SELECT t_multiplechoice.title, t_multiplechoice.answer, t_multiplechoice.hardLevel, t_multiplechoice.score, t_multiplechoice.date, t_multiplechoice.analysis, t_multiplechoice.choiceNum, t_multiplechoice.choiceA, t_multiplechoice.choiceB, t_multiplechoice.choiceC, t_multiplechoice.choiceD, t_multiplechoice.choiceE, t_multiplechoice.choiceF, t_teacher.name, t_course.name AS Expr1 FROM t_multiplechoice INNER JOIN t_teacher ON t_multiplechoice.teacherId = t_teacher.id INNER JOIN t_course ON t_teacher.courseId = t_course.id">
    </asp:SqlDataSource>


</form>
</asp:Content>

